package com.luotao.test.trade;

/**
 * User: luotao
 * Date: 12-5-19
 * Time: 22:06
 */
public class Flow {
    public static final String SQL_INSERT = "INSERT INTO `test`.`test_flow1` \n" +
            "\t(\n" +
            "\t`userid`, \n" +
            "\t`chargeAmount`, \n" +
            "\t`chargeAmountBefore`, \n" +
            "\t`chargeAmountAfter`, \n" +
            "\t`awardAmount`, \n" +
            "\t`awardAmountBefore`, \n" +
            "\t`awardAmountAfter`, \n" +
            "\t`lotAmount`, \n" +
            "\t`lotAmountBefore`, \n" +
            "\t`lotAmountAfter`, \n" +
            "\t`sendtype`, \n" +
         //   "\t`createtime`, \n" +
            "\t`confirmtime`, \n" +
            "\t`mapFlowId`, \n" +
            "\t`tradeMemo`, \n" +
            "\t`gameid`, \n" +
            "\t`bingoAmount`, \n" +
            "\t`channel`, \n" +
            "\t`mobileOSType`, \n" +
            "\t`ticketcode`, \n" +
            "\t`ticketcontent`, \n" +
            "\t`multiple`, \n" +
            "\t`isAword`, \n" +
            "\t`peroid`, \n" +
            "\t`ticketMemo`, \n" +
            "\t`autoBingoDate`, \n" +
            "\t`endBingoDate`\n" +
            "\t)\n" +
            "\tVALUES\n" +
            "\t(?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
       //     "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
         //   "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?\n" +
            "\t);";

    public static final String SQL_INSERT3 = "INSERT INTO `test`.`test_flow3` \n" +
            "\t( \n" +
            "\t`userid`, \n" +
            "\t`chargeAmount`, \n" +
            "\t`chargeAmountBefore`, \n" +
            "\t`chargeAmountAfter`, \n" +
            "\t`awardAmount`, \n" +
            "\t`awardAmountBefore`, \n" +
            "\t`awardAmountAfter`, \n" +
            "\t`lotAmount`, \n" +
            "\t`lotAmountBefore`, \n" +
            "\t`lotAmountAfter`, \n" +
            "\t`sendtype`, \n" +
         //   "\t`createtime`, \n" +
            "\t`confirmtime`, \n" +
            "\t`mapFlowId`, \n" +
            "\t`tradeMemo`, \n" +
            "\t`gameid`, \n" +
            "\t`bingoAmount`, \n" +
            "\t`channel`, \n" +
            "\t`mobileOSType`, \n" +
            "\t`ticketcode`, \n" +
            "\t`ticketcontent`, \n" +
            "\t`multiple`, \n" +
            "\t`isAword`, \n" +
            "\t`peroid`, \n" +
            "\t`ticketMemo`, \n" +
            "\t`autoBingoDate`, \n" +
            "\t`endBingoDate`\n" +
            "\t)\n" +
            "\tVALUES\n" +
            "\t(?, \n" +
            "\t?, \n" +
            "\t?, \n" +
        //    "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
         //   "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?\n" +
            "\t);";

    public static final String SQL_INSERT4 = "INSERT INTO `test`.`test_flow4` \n" +
            "\t(\n" +
            "\t`userid`, \n" +
            "\t`chargeAmount`, \n" +
            "\t`chargeAmountBefore`, \n" +
            "\t`chargeAmountAfter`, \n" +
            "\t`awardAmount`, \n" +
            "\t`awardAmountBefore`, \n" +
            "\t`awardAmountAfter`, \n" +
            "\t`lotAmount`, \n" +
            "\t`lotAmountBefore`, \n" +
            "\t`lotAmountAfter`, \n" +
            "\t`sendtype`, \n" +
         //   "\t`createtime`, \n" +
            "\t`confirmtime`, \n" +
            "\t`mapFlowId`, \n" +
            "\t`tradeMemo`, \n" +
            "\t`gameid`, \n" +
            "\t`bingoAmount`, \n" +
            "\t`channel`, \n" +
            "\t`mobileOSType`, \n" +
            "\t`ticketcode`, \n" +
            "\t`ticketcontent`, \n" +
            "\t`multiple`, \n" +
            "\t`isAword`, \n" +
            "\t`peroid`, \n" +
            "\t`ticketMemo`, \n" +
            "\t`autoBingoDate`, \n" +
            "\t`endBingoDate`\n" +
            "\t)\n" +
            "\tVALUES\n" +
            "\t(?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
         //   "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
         //   "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?, \n" +
            "\t?\n" +
            "\t);";
}
